Project Report
Background
New York City is infamous for the rats that live among us. Our apartments, buildings, subway stations, trash cans, parks, and streets are home to millions of rats and other rodents. For many New Yorkers, rats are an inevitable part of everyday life, and one that has worsened in recent years. This year alone (2022), New York’s Sanitation Department has reported more than 21,600 rat complaints. This represents a 71% increase since October 2020. The issue has gotten so bad that Mayor Adams is now looking to hire a “bloodthirsty” director of rodent mitigation, who is eligible to make up to $228,000. Given the prevalence of rats in this city and the recent urgency of the issue, this project primarily seeks to explore trends in rat sightings across New York City.
Further, research shows that exposure to rodents is associated with various diseases and poor health outcomes, including asthma symptoms. Asthma symptoms have been increasing in middle to high-income countries, making this issue ever more critical . Understanding it can aid public health and health care combat diseases from these exposures. This is particularly an issue among communities that are historically and continually oppressed through racism and classism as they live in environments with higher levels of exposure due to air pollution, old buildings, cigarette smoke, and other factors. This project secondarily seeks to explore associations between rodent infestations and asthma prevalence in New York City.
A 2019 study examined what neighborhoods are “rat hotspots.” It focused on data from 2010 to 2017. It looked at changes in number of sightings over the years as well as sightings by neighborhood. In 2016 there was a peak in the number of sightings. Brooklyn seemed to have the most sightings compared to other NYC boroughs. And they mostly occurred in 3+ family apartment buildings. The study also looked at high density areas - for example parts of the Upper West Side had a higher density of sightings compared to the Upper East Side. We will explore similar topics, using current data for 2022.
Questions
This project is motivated by the following questions:
- What trends are there in rat sightings throughout NYC?
- How do rat sightings vary by borough?
- How do rat sightings vary by location type?
- How are rodent trends associated with asthma trends?
Data and Cleaning Process
This project uses two main datasets for our analysis.
Rat Sightings
The Rat Sightings data is from NYC OpenData. This dataset includes information for all rat-related 311 service requests from 2010 to the present. We stored the data [locally? G drive?] since it was too large to upload to github. To clean the data, we changed the created_date variable from MM/DD/YYYY HH:MM into separate “month,” “day,” and “year” variables; made the year variable numeric; corrected capitalization fro address_type, city, and borough; recoded values for clarity; and filtered to remove observations in unspecified boroughs. After cleaning the data, our key variables are:
- month: month of rat sighting service request
- day: day of rat sighting service request
- year: year of rat sighting service request
- location_type: location type of rat sighting
- address_type: address type of rat sighting
- city: city of rat sighting
- borough: borough of rat sighting
- latitude: geo based latitude of incident location
- longitude: geo based longitude of incident location
Asthma
The Asthma Data is from the New York State Asthma Dashboard. The asthma data set includes information on asthma rates in NYC. To clean the data, we renamed variables for clarity, updated variable types, and grouped information by year and borough. After cleaning, key variables include:
- year: year
- geography: borough
- number: number of asthma-related ER visits
- age_adjusted_rate_per_10_000: age-adjusted asthma-related ER visit rates per 10,000
- estimated_annual_rate_per_10_000: estimated asthma-related annual ER visit rate per 10,000
For our statistical analyses, we also merged the Rat Sightings and Asthma datasets by year and borough.
Exploratory Analysis
To better understand trends in rat sightings in NYC, we conducted some exploratory analysis using data visualization.
First, we plotted rat sightings over time. Next, we explored the distribution of rat sighting frequency by borough and over time. Then, we explored top location types of rat sightings (i.e. apartment versus street versus park). Finally, we mapped rat sightings across the city using a density map.
Sightings over time
New York City
First, we wanted to get a sense of rat sighting trends over time. The following line graph shows how the number of sightings have changed over time:
Based on the plot, we see that rat sightings have generally increased since 2010, except for a brief decline between 2017 and 2020. Since 2020, the number of rat sightings in NYC has sharply increased.
By Borough
With a better understanding of general trends, we wanted to explore rat sighting trends over time by borough. The following line graph shows how the number of sightings has changed over time, color-coded by borough:
Based on the plot, we see that the Bronx, Brooklyn, Manhattan, and Queens generally follow similar trends as NYC overall. Of these boroughs, the Bronx deviates the most, showing a decrease in rat sightings since 2021. Staten Island is different from all other boroughs and NYC overall. Rat sightings there have remained steady, and low, since 2010.
Sightings Frequency
By Borough
The following bar graph shows the distribution of rat sighting frequency by borough between 2010 and 2022:
The plot shows that Brooklyn has the most rat sightings overall, with more than 70,000 sightings reported. Staten Island has the least number of sightings, with less than 10,000 sightings reported.
By Borough and Year
This bar graph shows the distribution of rat sighting frequency by borough for each year with available data.
Since 2010, the overall frequency ranking of each borough has remained the same: from least to greatest, Staten Island, Queens, The Bronx, Manhattan, and Brooklyn. Since 2020, sightings have increased most significantly in Manhattan and Brooklyn. With the Bronx’s decrease since 2021, the Bronx and Queens are nearly tied so far in 2022.
Top Location Types
New York City
The bar graph shows the distribution of rat sightings frequency by location type.
Overall, 3+ family apartment buildings had the highest number of sightings followed by 1-2 family dwellings. Of the top 10 location types, parking lots/garages had the lowest.
By Borough
The following bar graph shows the distribution of number of sightings by top sighting locations by borough:
In all boroughs except Queens and Staten Island, the highest number of sightings were in 3+ family apartment buildings. In Queens and Staten Island, the highest number of sightings were in 1-2 family dwellings.
Mapping
Finally, we mapped rat sightings across NYC by density:
As expected, we see rat sightings all over the city, with more rat sightings occurring in higher-density areas in the high-sighting boroughs identified in our previous plots.